Pandas Profiling Report

Dataset statistics

Number of variables	10
Number of observations	752
Missing cells	388
Missing cells (%)	5.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	58.9 KiB
Average record size in memory	80.2 B

Variable types

NUM	9
BOOL	1

Reproduction

Analysis started	2020-08-05 18:43:09.164852
Analysis finished	2020-08-05 18:43:25.979447
Duration	16.81 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`BloodPressure` has 28 (3.7%) missing values	Missing
`Insulin` has 360 (47.9%) missing values	Missing
`df_index` has unique values	Unique
`Pregnancies` has 108 (14.4%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	752
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	385.01462765957444
Minimum	0
Maximum	767
Zeros	1
Zeros (%)	0.1%
Memory size	5.9 KiB

Quantile statistics

Minimum	0
5-th percentile	38.55
Q1	194.75
median	385.5
Q3	577.25
95-th percentile	729.45
Maximum	767
Range	767
Interquartile range (IQR)	382.5

Descriptive statistics

Standard deviation	221.5469605
Coefficient of variation (CV)	0.575424788
Kurtosis	-1.198922796
Mean	385.0146277
Median Absolute Deviation (MAD)	191.5
Skewness	-0.003831991044
Sum	289531
Variance	49083.05571

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
767	1	0.1%
253	1	0.1%
262	1	0.1%
261	1	0.1%
260	1	0.1%
259	1	0.1%
258	1	0.1%
257	1	0.1%
256	1	0.1%
255	1	0.1%
Other values (742)	742	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%

Value	Count	Frequency (%)
767	1	0.1%
766	1	0.1%
765	1	0.1%
764	1	0.1%
763	1	0.1%

Pregnancies
Real number (ℝ_≥0)

ZEROS

Distinct count	17
Unique (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.851063829787234
Minimum	0
Maximum	17
Zeros	108
Zeros (%)	14.4%
Memory size	5.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	6
95-th percentile	10
Maximum	17
Range	17
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.375189327
Coefficient of variation (CV)	0.8764303778
Kurtosis	0.1705680019
Mean	3.85106383
Median Absolute Deviation (MAD)	2
Skewness	0.9072902384
Sum	2896
Variance	11.39190299

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	132	17.6%
0	108	14.4%
2	101	13.4%
3	74	9.8%
4	68	9.0%
5	55	7.3%
6	48	6.4%
7	44	5.9%
8	37	4.9%
9	28	3.7%
Other values (7)	57	7.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	108	14.4%
1	132	17.6%
2	101	13.4%
3	74	9.8%
4	68	9.0%

Value	Count	Frequency (%)
17	1	0.1%
15	1	0.1%
14	2	0.3%
13	10	1.3%
12	9	1.2%

Glucose
Real number (ℝ_≥0)

Distinct count	135
Unique (%)	18.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	121.94148936170212
Minimum	44.0
Maximum	199.0
Zeros	0
Zeros (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	44
5-th percentile	80
Q1	99.75
median	117
Q3	141
95-th percentile	181
Maximum	199
Range	155
Interquartile range (IQR)	41.25

Descriptive statistics

Standard deviation	30.60119806
Coefficient of variation (CV)	0.2509498467
Kurtosis	-0.2954030665
Mean	121.9414894
Median Absolute Deviation (MAD)	20
Skewness	0.5226732772
Sum	91700
Variance	936.4333229

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
100	17	2.3%
99	17	2.3%
129	14	1.9%
111	14	1.9%
106	14	1.9%
112	13	1.7%
108	13	1.7%
95	13	1.7%
125	13	1.7%
109	12	1.6%
Other values (125)	612	81.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
44	1	0.1%
56	1	0.1%
57	2	0.3%
61	1	0.1%
62	1	0.1%

Value	Count	Frequency (%)
199	1	0.1%
198	1	0.1%
197	4	0.5%
196	3	0.4%
195	2	0.3%

BloodPressure
Real number (ℝ_≥0)

MISSING

Distinct count	46
Unique (%)	6.4%
Missing	28
Missing (%)	3.7%
Infinite	0
Infinite (%)	0.0%

Mean	72.40055248618785
Minimum	24.0
Maximum	122.0
Zeros	0
Zeros (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	24
5-th percentile	52
Q1	64
median	72
Q3	80
95-th percentile	91.7
Maximum	122
Range	98
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	12.37987032
Coefficient of variation (CV)	0.1709913792
Kurtosis	0.9228827146
Mean	72.40055249
Median Absolute Deviation (MAD)	8
Skewness	0.1376292303
Sum	52418
Variance	153.2611892

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
70	57	7.6%
74	51	6.8%
78	45	6.0%
72	44	5.9%
68	43	5.7%
64	42	5.6%
80	39	5.2%
76	39	5.2%
60	37	4.9%
62	34	4.5%
Other values (36)	293	39.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
24	1	0.1%
30	2	0.3%
38	1	0.1%
40	1	0.1%
44	4	0.5%

Value	Count	Frequency (%)
122	1	0.1%
114	1	0.1%
110	3	0.4%
108	2	0.3%
106	3	0.4%

SkinThickness
Real number (ℝ_≥0)

Distinct count	51
Unique (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	29.172284644194754
Minimum	7.0
Maximum	99.0
Zeros	0
Zeros (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	7
5-th percentile	14
Q1	25
median	29.17228464
Q3	32
95-th percentile	44
Maximum	99
Range	92
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	8.852102582
Coefficient of variation (CV)	0.303442212
Kurtosis	5.344832133
Mean	29.17228464
Median Absolute Deviation (MAD)	3.827715356
Skewness	0.8162601036
Sum	21937.55805
Variance	78.35972012

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
29.17228464	218	29.0%
32	30	4.0%
30	27	3.6%
27	23	3.1%
23	20	2.7%
33	20	2.7%
28	20	2.7%
18	20	2.7%
31	19	2.5%
19	18	2.4%
Other values (41)	337	44.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	2	0.3%
8	2	0.3%
10	5	0.7%
11	6	0.8%
12	7	0.9%

Value	Count	Frequency (%)
99	1	0.1%
63	1	0.1%
60	1	0.1%
56	1	0.1%
54	2	0.3%

Insulin
Real number (ℝ_≥0)

MISSING

Distinct count	184
Unique (%)	46.9%
Missing	360
Missing (%)	47.9%
Infinite	0
Infinite (%)	0.0%

Mean	156.05612244897958
Minimum	14.0
Maximum	846.0
Zeros	0
Zeros (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	14
5-th percentile	42.55
Q1	76.75
median	125.5
Q3	190
95-th percentile	396.5
Maximum	846
Range	832
Interquartile range (IQR)	113.25

Descriptive statistics

Standard deviation	118.8416898
Coefficient of variation (CV)	0.7615317355
Kurtosis	6.356505089
Mean	156.0561224
Median Absolute Deviation (MAD)	54.5
Skewness	2.165116186
Sum	61174
Variance	14123.34723

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
105	11	1.5%
140	9	1.2%
130	9	1.2%
120	8	1.1%
94	7	0.9%
100	7	0.9%
180	7	0.9%
110	6	0.8%
135	6	0.8%
115	6	0.8%
Other values (174)	316	42.0%
(Missing)	360	47.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14	1	0.1%
15	1	0.1%
16	1	0.1%
18	2	0.3%
22	1	0.1%

Value	Count	Frequency (%)
846	1	0.1%
744	1	0.1%
680	1	0.1%
600	1	0.1%
579	1	0.1%

BMI
Real number (ℝ_≥0)

Distinct count	246
Unique (%)	32.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	32.45465425531915
Minimum	18.2
Maximum	67.1
Zeros	0
Zeros (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	18.2
5-th percentile	22.2
Q1	27.5
median	32.3
Q3	36.6
95-th percentile	44.5
Maximum	67.1
Range	48.9
Interquartile range (IQR)	9.1

Descriptive statistics

Standard deviation	6.928926198
Coefficient of variation (CV)	0.2134956097
Kurtosis	0.8748420787
Mean	32.45465426
Median Absolute Deviation (MAD)	4.6
Skewness	0.5968157768
Sum	24405.9
Variance	48.01001826

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
32	12	1.6%
31.2	12	1.6%
31.6	12	1.6%
32.4	10	1.3%
33.3	10	1.3%
30.8	9	1.2%
32.8	9	1.2%
32.9	9	1.2%
30.1	9	1.2%
34.2	8	1.1%
Other values (236)	652	86.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18.2	3	0.4%
18.4	1	0.1%
19.1	1	0.1%
19.3	1	0.1%
19.4	1	0.1%

Value	Count	Frequency (%)
67.1	1	0.1%
59.4	1	0.1%
57.3	1	0.1%
55	1	0.1%
53.2	1	0.1%

DiabetesPedigreeFunction
Real number (ℝ_≥0)

Distinct count	511
Unique (%)	68.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.47305053191489366
Minimum	0.078
Maximum	2.42
Zeros	0
Zeros (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	0.078
5-th percentile	0.141
Q1	0.244
median	0.377
Q3	0.6275
95-th percentile	1.13105
Maximum	2.42
Range	2.342
Interquartile range (IQR)	0.3835

Descriptive statistics

Standard deviation	0.3301080525
Coefficient of variation (CV)	0.6978283085
Kurtosis	5.592024879
Mean	0.4730505319
Median Absolute Deviation (MAD)	0.17
Skewness	1.9040609
Sum	355.734
Variance	0.1089713263

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.258	6	0.8%
0.254	6	0.8%
0.238	5	0.7%
0.207	5	0.7%
0.259	5	0.7%
0.268	5	0.7%
0.692	4	0.5%
0.263	4	0.5%
0.197	4	0.5%
0.551	4	0.5%
Other values (501)	704	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.078	1	0.1%
0.084	1	0.1%
0.085	2	0.3%
0.088	2	0.3%
0.089	1	0.1%

Value	Count	Frequency (%)
2.42	1	0.1%
2.329	1	0.1%
2.288	1	0.1%
2.137	1	0.1%
1.893	1	0.1%

Age
Real number (ℝ_≥0)

Distinct count	52
Unique (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	33.3125
Minimum	21
Maximum	81
Zeros	0
Zeros (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	21
5-th percentile	21
Q1	24
median	29
Q3	41
95-th percentile	58
Maximum	81
Range	60
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.70939523
Coefficient of variation (CV)	0.3515015455
Kurtosis	0.6166577132
Mean	33.3125
Median Absolute Deviation (MAD)	7
Skewness	1.116815734
Sum	25051
Variance	137.1099368

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
22	68	9.0%
21	59	7.8%
25	47	6.2%
24	45	6.0%
23	38	5.1%
28	35	4.7%
26	32	4.3%
27	32	4.3%
29	29	3.9%
31	24	3.2%
Other values (42)	343	45.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
21	59	7.8%
22	68	9.0%
23	38	5.1%
24	45	6.0%
25	47	6.2%

Value	Count	Frequency (%)
81	1	0.1%
72	1	0.1%
70	1	0.1%
69	1	0.1%
68	1	0.1%

Outcome
Boolean

Distinct count	2
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	5.9 KiB

0	488
1	264

Frequency Table

Value	Count	Frequency (%)
0	488	64.9%
1	264	35.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	df_index	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome
0	0	6	148.0	72.0	35.000000	NaN	33.6	0.627	50	1
1	1	1	85.0	66.0	29.000000	NaN	26.6	0.351	31	0
2	2	8	183.0	64.0	29.172285	NaN	23.3	0.672	32	1
3	3	1	89.0	66.0	23.000000	94.0	28.1	0.167	21	0
4	4	0	137.0	40.0	35.000000	168.0	43.1	2.288	33	1
5	5	5	116.0	74.0	29.172285	NaN	25.6	0.201	30	0
6	6	3	78.0	50.0	32.000000	88.0	31.0	0.248	26	1
7	7	10	115.0	NaN	29.172285	NaN	35.3	0.134	29	0
8	8	2	197.0	70.0	45.000000	543.0	30.5	0.158	53	1
9	10	4	110.0	92.0	29.172285	NaN	37.6	0.191	30	0

Last rows

	df_index	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome
742	758	1	106.0	76.0	29.172285	NaN	37.5	0.197	26	0
743	759	6	190.0	92.0	29.172285	NaN	35.5	0.278	66	1
744	760	2	88.0	58.0	26.000000	16.0	28.4	0.766	22	0
745	761	9	170.0	74.0	31.000000	NaN	44.0	0.403	43	1
746	762	9	89.0	62.0	29.172285	NaN	22.5	0.142	33	0
747	763	10	101.0	76.0	48.000000	180.0	32.9	0.171	63	0
748	764	2	122.0	70.0	27.000000	NaN	36.8	0.340	27	0
749	765	5	121.0	72.0	23.000000	112.0	26.2	0.245	30	0
750	766	1	126.0	60.0	29.172285	NaN	30.1	0.349	47	1
751	767	1	93.0	70.0	31.000000	NaN	30.4	0.315	23	0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows